if __name__ == '__main__':
    import pandas as pd

    df = pd.read_excel("D:\\家宽\\调研记录2025-1-3(v1.2).xlsx", usecols=range(1, 6))
    df2 = pd.read_csv("D:\\家宽\\小区中断对比.csv")
    df = df.merge(df2, left_on='小区名称', right_on='所属小区', how='left')
    df.to_excel("D:\\家宽\\调研小区中断对比.xlsx")
